select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Elegant Purple Ball Gown Sweetheart Taffeta Sash Dress for Quince

Dark Purple Sweetheart Pick-ups Quinceanera Dresses with White Bow

Best Lilac Ball Gown Sweetheart Multi-tiered Quinceanera Gown

Grass Green Spaghetti Straps Ruched Quince Dresses with Ruffles

Spring Green Sweetheart Pleated Embroidery Beading Quince Dresses

New Arrival Orange Taffeta Strapless Pick-ups Dress for Sweet 15

Coral Red Strapless Appliques Ruffles Hand Made Flower Quince Dresses

New Colorful Strapless Appliques and Ruffles Sweet 15 Dresses

Black and Green Beaded and Embroidery Decorate Quince Dresses

Multi-Color Strapless Beading Ruches Puffy Quinceanera Dresses

Popular Colorful Ruffled Layers and Appliques Quinceanera Gown

Best Puffy Pink Strapless Dress for Sweet 15 with Flora Appliques

Colorful off the Shoulder Pick-ups Lace Decorate Sweet 15 Dresses

Sweetheart Hand Made Flowers Ruffled Quinceanera Dresses

Strapless Taffeta Pleats and Appliques Beading Dress for Quince

Colorful Ball Gown Strapless Organza Beading Sweet 15 Dresses

Dark Grey Floor-length Organza Appliques Sweet Sixteen Dresses

Popular Royal Blue Floor-length Organza Dresses for Quince

Yellow Floor-length Organza Appliques Dress for Quinceaneras

Green Strapless Organza Dress for Quinceanera with Appliques

Purple Floor-length Taffeta Appliques Dress for Quince

Discount Sweetheart Taffeta Dress for Quince with Appliques

Red Taffeta Appliques Floor-length Quinceanera Dresses

Two Toned Taffeta Dress for Quinceaneras with Pick Ups

Lovely Yellow Green Beaded Dress for Quince with Ruffles

Purple and Leopard Taffeta Dress for Quince with Ruffles

Yellow Floor-length Taffeta Pick-ups Dress for Quinceaneras

Black and Olive Green Organza Sweet 16 Dresses with Appliques

White Organza Beaded Sweet Sixteen Dresses with Train

Beaded One Shoulder Taffeta and Organza Flowers Quince Dress